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