UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'roy+8WeBh33gHpXhzT6BLWUE3fb7Nm/rWXpwUgsWfl8='
WHERE
key_id = '5cd7e7db80f088648eac6739e0ab16f676c7a019430829da9c41b64aa964feb1'
AND (
token = 'roy+8WeBh33gHpXhzT6BLWUE3fb7Nm/rWXpwUgsWfl8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)