UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hWpG9jdc6yDI4m3RprjoE5EXcOVPC9XtXhj20m47S08='
WHERE
key_id = '485adeb47a384635115c5660e4c19988b8587921ee3ebfd3810c832495ef090e'
AND (
token = 'hWpG9jdc6yDI4m3RprjoE5EXcOVPC9XtXhj20m47S08='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)