UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pXWXAfhP4aYCeqmMjmWZjJtXvolv6N0wdn2Mxbcmeig='
WHERE
key_id = '3beef6de9b78ac7b26b30074db309245f062741b2a69bfa9f4e059ccb28fa6f2'
AND (
token = 'pXWXAfhP4aYCeqmMjmWZjJtXvolv6N0wdn2Mxbcmeig='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)