UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'br+h3JeOUFaD3Y2K5e3yZXkZvocA8vMRntGy6xOoWeE='
WHERE
key_id = 'e9ed7eb2f95b10400678a00a4410b0527a14a26837a7d410d0623c117c55b380'
AND (
token = 'br+h3JeOUFaD3Y2K5e3yZXkZvocA8vMRntGy6xOoWeE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)