UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3pl+hmC2qMDgNMBS3LvS9t7U46LhCZPnrWFMYFgeEsA='
WHERE
key_id = '296957ca5a1d7d75bfda01337cf7a0709019879b6c7d81c66cf8ae182f8bb9a9'
AND (
token = '3pl+hmC2qMDgNMBS3LvS9t7U46LhCZPnrWFMYFgeEsA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)