UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5QgR509a20aTllcmN4D++rpBSLGrVwor8akEgo6JUQU='
WHERE
key_id = '6582f1f5be41036c82c0b85238f9d6f6267d3afe5ef6303ada406b2c2073b244'
AND (
token = '5QgR509a20aTllcmN4D++rpBSLGrVwor8akEgo6JUQU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)