UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HX03gGMs9+xy8kRQ27OwYBp9JJKZW5e4rHXW1VvDkLw='
WHERE
key_id = 'fc22a2544336dcd490805a7eb621519e05fb2eef15656eddf6896064917b8096'
AND (
token = 'HX03gGMs9+xy8kRQ27OwYBp9JJKZW5e4rHXW1VvDkLw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)