UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hS+vgB5t0EXnMpJd4GEZsc8obu5iZV8qu3Zd5Oczj5s='
WHERE
key_id = '9e14a04878863c5621dd2f32711a97e4cb2eec6dde49d4bfcfb8a8e185262aa9'
AND (
token = 'hS+vgB5t0EXnMpJd4GEZsc8obu5iZV8qu3Zd5Oczj5s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)