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