UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/QRN6bvvcBKeyIfay7TDU5k3kK1RGzj4asBnnDx1LrM='
WHERE
key_id = 'b9f7a29a162f0503c1816432b4f48a6b9d6b04ab005a8efc0029cff934884148'
AND (
token = '/QRN6bvvcBKeyIfay7TDU5k3kK1RGzj4asBnnDx1LrM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)