UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xyeU5gbrKacLtC9bkJRaHPn5nkIj5Og55RCNBiXRAE8='
WHERE
key_id = '6c828bca07ddcf6442ff6966842a1263844760fa5ac2dc3254a107d13a427359'
AND (
token = 'xyeU5gbrKacLtC9bkJRaHPn5nkIj5Og55RCNBiXRAE8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)