UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LxTdOtpNV6HlussJ6n1WXXbGC3TPU4YVy0iSeOk6ybo='
WHERE
key_id = 'faf3efc2341c028d199d5a9c34a4403a2152577c44729526b9b00aa1911baeb2'
AND (
token = 'LxTdOtpNV6HlussJ6n1WXXbGC3TPU4YVy0iSeOk6ybo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)