UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pgC4fblbfivGnwJbSzpCNoU47x54Snr+UgxP9n714Bc='
WHERE
key_id = '4a31a2ac4b697be8805a57b9dd881c36f436673e80432fc7213c77e05c03f5e4'
AND (
token = 'pgC4fblbfivGnwJbSzpCNoU47x54Snr+UgxP9n714Bc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)