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