UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oImlQwSKM1uhWpqKj6zgwk3eVRbdvvJi3YmTsxoH0+s='
WHERE
key_id = 'b7ca1836fee0971f133bfae320e81499148404cee0badef17b9aefde5c804dd9'
AND (
token = 'oImlQwSKM1uhWpqKj6zgwk3eVRbdvvJi3YmTsxoH0+s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)