UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zsBkQ+xjuAKuLt6gbTZGxntJiATe6lMShlLYQO0iMUM='
WHERE
key_id = '23f6c8984232f847ed2bbcc3065740a20697ec98dd8b10f42954f56dd6a95fe1'
AND (
token = 'zsBkQ+xjuAKuLt6gbTZGxntJiATe6lMShlLYQO0iMUM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)