UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8C97KYZpJ9Q5uPB0p8AQ9vyFjnFvhum36FCsG+D1ozo='
WHERE
key_id = '7ff93f02920847a5a5d931ee9490fc45882da94f08d7b787b3a52f19b6f35e20'
AND (
token = '8C97KYZpJ9Q5uPB0p8AQ9vyFjnFvhum36FCsG+D1ozo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)