UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7Fwa3F3modk7gZNgJcRY7a0/SW+2Lxz0dFxA64Ryns4='
WHERE
key_id = '4fdb7fbf56b5eb466c24d40dfcaa66b37ea5cb1bcaa07faea283f6fbd65de716'
AND (
token = '7Fwa3F3modk7gZNgJcRY7a0/SW+2Lxz0dFxA64Ryns4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)