UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1hFk5Lh6DB6ZyBefBekODd91XNuXliz6idtTESKDi80='
WHERE
key_id = 'a05ea1536d2e2de81881a0a35c262024cf254b15645b834a49f640b05d03ba65'
AND (
token = '1hFk5Lh6DB6ZyBefBekODd91XNuXliz6idtTESKDi80='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)