UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'btA43qCO83tFyYW2Y7+ViFCpAHjFdwzr8qTiyxNJqrw='
WHERE
key_id = 'b24561a0b30e66365fef672123d960834fcf43480f1166cc62a7576902cf9e9b'
AND (
token = 'btA43qCO83tFyYW2Y7+ViFCpAHjFdwzr8qTiyxNJqrw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)