UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4u7Hbim3QR5Z0ITzJAQotZGALzc/IXBW8ZlkM/8PBFE='
WHERE
key_id = 'a9bd2c93ff9a63809f6082e90052e7ea03de7fd05ecc0544e26e4b53bcf403c4'
AND (
token = '4u7Hbim3QR5Z0ITzJAQotZGALzc/IXBW8ZlkM/8PBFE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)