UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ri2ITrjUJQcXGTXuHhX15vpNeiMqf/Rw0Fi/9ISebyg='
WHERE
key_id = '267a5ede7c278bf17ccc794a874157dbd3e9b633bbc5c4adbb0c2e72fa05caf9'
AND (
token = 'ri2ITrjUJQcXGTXuHhX15vpNeiMqf/Rw0Fi/9ISebyg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)