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