UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oCCfAakB/OoLG+lL2AxUT+baG9dgD4rkPMEuw2nSrmU='
WHERE
key_id = '9baa742e8e55867228a2af3ce562902b140fd42e8274112457bd6899f4ebc2ee'
AND (
token = 'oCCfAakB/OoLG+lL2AxUT+baG9dgD4rkPMEuw2nSrmU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)