UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Zs6TyWZjRnGtN+QnEcZCuuhhKfzxeJDnA4L5Y28crb8='
WHERE
key_id = '1526fdba1f9189eb3b392efbfd1afb3e617d9b04f29534d608856f43dd445217'
AND (
token = 'Zs6TyWZjRnGtN+QnEcZCuuhhKfzxeJDnA4L5Y28crb8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)