UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2SqHuY0nxkBxa0MuEUEu749gtoz9bzsqr7QqX746MG8='
WHERE
key_id = 'd9a85f0be75fb2f172cf042d1b516b6a1e8732e91f1199ed2d5ed616994488a0'
AND (
token = '2SqHuY0nxkBxa0MuEUEu749gtoz9bzsqr7QqX746MG8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)