UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qiHbfmpV376xloqIfdZTNNgbYuTiVymUeF/3QxlVX4w='
WHERE
key_id = 'ec285191a6431e4bae3ebda916b6f28f17307a9c309af7b96ce53aae57d705fd'
AND (
token = 'qiHbfmpV376xloqIfdZTNNgbYuTiVymUeF/3QxlVX4w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)