UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/9bRw40sA7F9bcZoodROVsQLamDKGLQ6aa4gUsXg3j0='
WHERE
key_id = '523b21747fae761bc4f6e666de17270dcab0d0fd6ba7dde8d4a826234bdb3cc0'
AND (
token = '/9bRw40sA7F9bcZoodROVsQLamDKGLQ6aa4gUsXg3j0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)