UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X0qXmI1k7LMLL41HGgBjM1+GfyVHvBqKB1lYIqfNxBc='
WHERE
key_id = '6bf91cece43ea3a7e2366d697718ee158b57fc3471545d8599ad4caee6256a40'
AND (
token = 'X0qXmI1k7LMLL41HGgBjM1+GfyVHvBqKB1lYIqfNxBc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)