UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Mc7dArlMZJZCgKwPbWbNHzIpbsGUOgS7/Fpx8x18JOo='
WHERE
key_id = '6ffabef0430290d997d1648d9028741d27a41b08d084fe35f8f8112d68a72289'
AND (
token = 'Mc7dArlMZJZCgKwPbWbNHzIpbsGUOgS7/Fpx8x18JOo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)