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