UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ovszdtrOxoDqlmv9zhoo78kjI4pJTz8TcPWJWP5F59w='
WHERE
key_id = '31887a109f2358ae155a0027d248e18f0c056792a2475e8cbd9fc6dc346b030c'
AND (
token = 'ovszdtrOxoDqlmv9zhoo78kjI4pJTz8TcPWJWP5F59w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)