UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B0DlAjy7phEzb70qGpBM75ZQAdsoytRiS405qmuCVSo='
WHERE
key_id = 'a190beeb6826b8519736ef522280dbf7c464ea48b727789407a30c858e9ba5b4'
AND (
token = 'B0DlAjy7phEzb70qGpBM75ZQAdsoytRiS405qmuCVSo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)