UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 's8JpPWHxZ0A+/ZuRc3I1UVWEHR1cxyVC1lyNlkPEU28='
WHERE
key_id = 'ecaf0de808b82a2cd9ea5a59ff247dfcc4691dbba41b45a461e25537ed88f8fe'
AND (
token = 's8JpPWHxZ0A+/ZuRc3I1UVWEHR1cxyVC1lyNlkPEU28='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)